GiftRegistryLineItemAssociation

Entity Definition

Logical Name : GiftRegistryLineItemAssociation
Physical Name : AS_LTM_GF_RGST

A linkage of Items in a GiftRegistry that have been purchased.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) SaleReturnLineItem(TR_LTM_SLS_RTN)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SaleReturnLineItem(TR_LTM_SLS_RTN)
GiftRegistryID (FK)(PK) A unique system assigned identifier for this particular CustomerGiftRegistry. ID_RGST_CT_GF Identity integer GiftRegistryLineItem(AS_ITM_GF_RGST)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) GiftRegistryLineItem(AS_ITM_GF_RGST)
UnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM Code varchar(20) UnitOfMeasure(CO_UOM)
Quantity The number of items purchased for the GiftRegistration on this line item. QU_LTM_GF_RGST Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
UnitOfMeasure defines GiftRegistryLineItemAssociation
GiftRegistryLineItem is satisfied by GiftRegistryLineItemAssociation
SaleReturnLineItem is intended for GiftRegistryLineItemAssociation

Logical Views containing GiftRegistryLineItemAssociation

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 07010 - Customer Account Information Extended
Logical 07040 - Customer Segment Dependent Behavior
Logical 07200 - Customer Purchase Transaction History View